Stored Procedures [dbo].[BAEImisNameAddressGetPurposes]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
SQL Script
create procedure [dbo].[BAEImisNameAddressGetPurposes] as
SELECT ShortValue AS 'Purpose'
    FROM System_Params
    WHERE ParameterName LIKE 'Member_Control.Addr_Prompt'

GO
Uses